﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'SearchCargos')
	BEGIN
		DROP  Procedure  SearchCargos
	END

GO

CREATE Procedure SearchCargos

	(
		@nombre nvarchar(10)
	)

AS

BEGIN
	SET NOCOUNT ON
	
	SELECT
	[Descripcion],
	[IdArea],
	[IdCargo],
	[IdCargoSuperior],
	[Nombre]
	FROM [Cargo] 
	WHERE [Nombre] LIKE (@nombre + N'%')

	SET NOCOUNT OFF
END

GO


GRANT EXEC ON SearchCargos TO PUBLIC

GO

